Overview

Dataset info

Number of variables24
Number of observations688651
Missing cells680435 (4.1%)
Duplicate rows0 (0.0%)
Total size in memory126.1 MiB
Average record size in memory192.0 B

Variables types

Numeric11
Categorical11
Boolean2
Date0
URL0
Text (Unique)0
Rejected0
Unsupported0

Warnings

ACCOUNT_CREATED_DATE has 49909 (7.2%) missing values Missing
AMOUNT_USD is highly skewed (γ1 = 654.2152316) Skewed
AMOUNT_USD has 12126 (1.8%) zeros Zeros
BIRTH_YEAR has 49909 (7.2%) missing values Missing
COUNTRY has 49909 (7.2%) missing values Missing
FAILED_SIGN_IN_ATTEMPTS is highly skewed (γ1 = 20.17361063) Skewed
FAILED_SIGN_IN_ATTEMPTS has 635042 (92.2%) zeros Zeros
FAILED_SIGN_IN_ATTEMPTS has 49909 (7.2%) missing values Missing
HAS_EMAIL has 49909 (7.2%) missing values Missing
IS_FRAUDSTER has 49909 (7.2%) missing values Missing
KYC has 49909 (7.2%) missing values Missing
MERCH_COUNTRIES_USED has 205596 (29.9%) missing values Missing
MERCHANT_COUNTRY has a high cardinality: 345 distinct values Warning
PHONE_COUNTRY has a high cardinality: 75 distinct values Warning
PHONE_COUNTRY has 49909 (7.2%) missing values Missing
ROLLING_AVG is highly skewed (γ1 = 75.16437548) Skewed
ROLLING_SUM is highly skewed (γ1 = 51.60844599) Skewed
TERMS_VERSION has 75567 (11.0%) missing values Missing
TIME_SINCE_LAST_TRANSACTION is highly skewed (γ1 = 21.23906615) Skewed
TIME_SINCE_LAST_TRANSACTION has 96868 (14.1%) zeros Zeros
USER_ID has a high cardinality: 8021 distinct values Warning

Variables

ACCOUNT_CREATED_DATE
Numeric

Distinct count7749
Unique (%)1.1%
Missing (%)7.2%
Missing (n)49909
Infinite (%)0.0%
Infinite (n)0
Mean513.2905681
Minimum0
Maximum940.0294827
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile96.35692163
Q1291.7099367
Median553.9698098
Q3722.4251147
95-th percentile857.0172394
Maximum940.0294827
Range940.0294827
Interquartile range430.715178

Descriptive statistics

Standard deviation245.9714487
Coef of variation0.4792050819
Kurtosis-1.113199889
Mean513.2905681
MAD212.660538
Skewness-0.2851815096
Sum327860244.1
Variance60501.9536
Memory size5.3 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
154.7391744 2725 0.4%
 
266.8504718 1888 0.3%
 
697.2446748 1856 0.3%
 
261.3337382 1802 0.3%
 
556.3107027 1725 0.3%
 
73.20995059 1559 0.2%
 
168.8945824 1513 0.2%
 
618.0554057 1496 0.2%
 
598.9775755 1448 0.2%
 
606.5665685 1441 0.2%
 
Other values (7738) 621289 90.2%
 
(Missing) 49909 7.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 148 < 0.1%
 
0.09821409722 165 < 0.1%
 
0.2424634259 7 < 0.1%
 
0.854335081 357 0.1%
 
0.8919533796 51 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
940.0294827 2 < 0.1%
 
940.0103932 2 < 0.1%
 
940.0069005 5 < 0.1%
 
939.8503398 2 < 0.1%
 
939.8478982 2 < 0.1%
 

AMOUNT_USD
Numeric

Distinct count32381
Unique (%)4.7%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean7130792.755
Minimum0
Maximum1.657094872e+12
Zeros (%)1.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile66
Q1515
Median1475
Q35406
95-th percentile33389
Maximum1.657094872e+12
Range1.657094872e+12
Interquartile range4891

Descriptive statistics

Standard deviation2248502125
Coef of variation315.3228823
Kurtosis455145.2689
Mean7130792.755
MAD14229081.08
Skewness654.2152316
Sum4.910627561e+12
Variance5.055761804e+18
Memory size5.3 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000000e+00 5.00000000e-01 1.50000000e+00 2.50000000e+00 4.50000000e+00 ... 1.90150601e+10 1.90524069e+10 1.93596944e+10 6.40808175e+10 1.65709487e+12], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1260 14434 2.1%
 
126 13815 2.0%
 
0 12126 1.8%
 
12606 10997 1.6%
 
111 10423 1.5%
 
6303 9065 1.3%
 
1112 8939 1.3%
 
2521 8182 1.2%
 
11129 7346 1.1%
 
2225 7005 1.0%
 
Other values (32371) 586319 85.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 12126 1.8%
 
1 1440 0.2%
 
2 506 0.1%
 
3 307 < 0.1%
 
4 237 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.657094872e+12 1 < 0.1%
 
8.285474362e+11 1 < 0.1%
 
1.082269209e+11 1 < 0.1%
 
6.649063054e+10 1 < 0.1%
 
6.167100452e+10 1 < 0.1%
 

BIRTH_YEAR
Numeric

Distinct count68
Unique (%)< 0.1%
Missing (%)7.2%
Missing (n)49909
Infinite (%)0.0%
Infinite (n)0
Mean1984.940629
Minimum1927
Maximum2000
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1927
5-th percentile1965
Q11980
Median1987
Q31992
95-th percentile1997
Maximum2000
Range73
Interquartile range12

Descriptive statistics

Standard deviation9.887921541
Coef of variation0.004981469671
Kurtosis1.929580814
Mean1984.940629
MAD7.529709605
Skewness-1.319251445
Sum1267864947
Variance97.7709924
Memory size5.3 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1991 40150 5.8%
 
1990 37738 5.5%
 
1993 34553 5.0%
 
1989 34429 5.0%
 
1994 32689 4.7%
 
1988 31719 4.6%
 
1987 30006 4.4%
 
1992 29374 4.3%
 
1984 28115 4.1%
 
1986 26033 3.8%
 
Other values (57) 313936 45.6%
 
(Missing) 49909 7.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1927 2 < 0.1%
 
1928 41 < 0.1%
 
1930 25 < 0.1%
 
1931 4 < 0.1%
 
1936 3 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2000 1255 0.2%
 
1999 4160 0.6%
 
1998 12837 1.9%
 
1997 17311 2.5%
 
1996 17788 2.6%
 

COUNT
Numeric

Distinct count2725
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean210.452762
Minimum1
Maximum2725
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile5
Q136
Median107
Q3271
95-th percentile769
Maximum2725
Range2724
Interquartile range235

Descriptive statistics

Standard deviation283.1574549
Coef of variation1.345467991
Kurtosis12.27753521
Mean210.452762
MAD190.1994128
Skewness2.933569474
Sum144928505
Variance80178.14426
Memory size5.3 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[1.0000e+00 1.5000e+00 2.5000e+00 3.5000e+00 5.5000e+00 ... 1.7255e+03 1.8565e+03 2.2935e+03 2.5715e+03 2.7250e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 8021 1.2%
 
2 7704 1.1%
 
3 6994 1.0%
 
4 6582 1.0%
 
5 6271 0.9%
 
6 6036 0.9%
 
7 5838 0.8%
 
8 5669 0.8%
 
9 5531 0.8%
 
10 5393 0.8%
 
Other values (2715) 624612 90.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 8021 1.2%
 
2 7704 1.1%
 
3 6994 1.0%
 
4 6582 1.0%
 
5 6271 0.9%
 

Maximum 5 values

ValueCountFrequency (%) 
2725 1 < 0.1%
 
2724 1 < 0.1%
 
2723 1 < 0.1%
 
2722 1 < 0.1%
 
2721 1 < 0.1%
 

COUNTRY
Categorical

Distinct count45
Unique (%)< 0.1%
Missing (%)7.2%
Missing (n)49909
GB
348946
FR
 
60041
LT
 
48154
Other values (41)
181601
(Missing)
 
49909
ValueCountFrequency (%) 
GB 348946 50.7%
 
FR 60041 8.7%
 
LT 48154 7.0%
 
IE 41723 6.1%
 
PL 25005 3.6%
 
ES 19311 2.8%
 
DE 8988 1.3%
 
PT 8137 1.2%
 
LV 7570 1.1%
 
RO 6903 1.0%
 
Other values (34) 63964 9.3%
 
(Missing) 49909 7.2%
 
Max length4
Mean length2.14494715
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

CURRENCIES_USED
Numeric

Distinct count8
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.26227799
Minimum1
Maximum8
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile2
Maximum8
Range7
Interquartile range0

Descriptive statistics

Standard deviation0.6042684084
Coef of variation0.4787126237
Kurtosis12.23482698
Mean1.26227799
MAD0.4204873932
Skewness2.976908195
Sum869269
Variance0.3651403093
Memory size5.3 MiB
Histogram
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%) 
1 552027 80.2%
 
2 103538 15.0%
 
3 25004 3.6%
 
4 6194 0.9%
 
5 1287 0.2%
 
6 365 0.1%
 
7 135 < 0.1%
 
8 101 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1 552027 80.2%
 
2 103538 15.0%
 
3 25004 3.6%
 
4 6194 0.9%
 
5 1287 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
8 101 < 0.1%
 
7 135 < 0.1%
 
6 365 0.1%
 
5 1287 0.2%
 
4 6194 0.9%
 

CURRENCY
Categorical

Distinct count29
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
GBP
339091
EUR
264695
USD
 
31542
Other values (26)
 
53323
ValueCountFrequency (%) 
GBP 339091 49.2%
 
EUR 264695 38.4%
 
USD 31542 4.6%
 
PLN 22362 3.2%
 
RON 5837 0.8%
 
CHF 5761 0.8%
 
NOK 2602 0.4%
 
AUD 2110 0.3%
 
DKK 1711 0.2%
 
SEK 1579 0.2%
 
Other values (19) 11361 1.6%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

ENTRY_METHOD
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
misc
227362
chip
183662
cont
160872
Other values (3)
116755
ValueCountFrequency (%) 
misc 227362 33.0%
 
chip 183662 26.7%
 
cont 160872 23.4%
 
manu 93952 13.6%
 
mags 22311 3.2%
 
mcon 492 0.1%
 
Max length4
Mean length4
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

FAILED_SIGN_IN_ATTEMPTS
Numeric

Distinct count6
Unique (%)< 0.1%
Missing (%)7.2%
Missing (n)49909
Infinite (%)0.0%
Infinite (n)0
Mean0.009551587339
Minimum0
Maximum6
Zeros (%)92.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum6
Range6
Interquartile range0

Descriptive statistics

Standard deviation0.1411770766
Coef of variation14.78048324
Kurtosis560.8706272
Mean0.009551587339
MAD0.01899251694
Skewness20.17361063
Sum6101
Variance0.01993096696
Memory size5.3 MiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
0 635042 92.2%
 
1 1762 0.3%
 
2 1715 0.2%
 
3 143 < 0.1%
 
6 80 < 0.1%
 
(Missing) 49909 7.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 635042 92.2%
 
1 1762 0.3%
 
2 1715 0.2%
 
3 143 < 0.1%
 
6 80 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
6 80 < 0.1%
 
3 143 < 0.1%
 
2 1715 0.2%
 
1 1762 0.3%
 
0 635042 92.2%
 

HAS_EMAIL
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)7.2%
Missing (n)49909
1
631879
0
 
6863
(Missing)
 
49909
ValueCountFrequency (%) 
1 631879 91.8%
 
0 6863 1.0%
 
(Missing) 49909 7.2%
 

IS_FRAUDSTER
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)7.2%
Missing (n)49909
False
624828
True
 
13914
(Missing)
 
49909
ValueCountFrequency (%) 
False 624828 90.7%
 
True 13914 2.0%
 
(Missing) 49909 7.2%
 

KYC
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)7.2%
Missing (n)49909
PASSED
629811
NONE
 
4879
PENDING
 
2283
(Missing)
 
49909
ValueCountFrequency (%) 
PASSED 629811 91.5%
 
NONE 4879 0.7%
 
PENDING 2283 0.3%
 
FAILED 1769 0.3%
 
(Missing) 49909 7.2%
 
Max length7
Mean length5.844198295
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

MERCH_COUNTRIES_USED
Numeric

Distinct count48
Unique (%)< 0.1%
Missing (%)29.9%
Missing (n)205596
Infinite (%)0.0%
Infinite (n)0
Mean3.266474832
Minimum1
Maximum47
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q34
95-th percentile10
Maximum47
Range46
Interquartile range3

Descriptive statistics

Standard deviation3.528709355
Coef of variation1.080280589
Kurtosis12.63899963
Mean3.266474832
MAD2.385861324
Skewness2.915221279
Sum1577887
Variance12.45178971
Memory size5.3 MiB
Histogram
Histogram with fixed size bins (bins=48)
ValueCountFrequency (%) 
1 195596 28.4%
 
2 93177 13.5%
 
3 56033 8.1%
 
4 32505 4.7%
 
5 27073 3.9%
 
6 19061 2.8%
 
7 12516 1.8%
 
8 9644 1.4%
 
9 8416 1.2%
 
10 5472 0.8%
 
Other values (37) 23562 3.4%
 
(Missing) 205596 29.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1 195596 28.4%
 
2 93177 13.5%
 
3 56033 8.1%
 
4 32505 4.7%
 
5 27073 3.9%
 

Maximum 5 values

ValueCountFrequency (%) 
47 1 < 0.1%
 
46 8 < 0.1%
 
45 1 < 0.1%
 
44 6 < 0.1%
 
43 12 < 0.1%
 

MERCHANT_COUNTRY
Categorical

Distinct count345
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
0
205596
GBR
146200
USA
 
46050
Other values (342)
290805
ValueCountFrequency (%) 
0 205596 29.9%
 
GBR 146200 21.2%
 
USA 46050 6.7%
 
FRA 28980 4.2%
 
IRL 26196 3.8%
 
LTU 25597 3.7%
 
ESP 23329 3.4%
 
NLD 18532 2.7%
 
AUS 10088 1.5%
 
POL 10028 1.5%
 
Other values (335) 148055 21.5%
 
Max length3
Mean length2.402250196
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

PHONE_COUNTRY
Categorical

Distinct count75
Unique (%)< 0.1%
Missing (%)7.2%
Missing (n)49909
GB||JE||IM||GG
328346
FR
 
63293
LT
 
48740
Other values (71)
198363
(Missing)
 
49909
ValueCountFrequency (%) 
GB||JE||IM||GG 328346 47.7%
 
FR 63293 9.2%
 
LT 48740 7.1%
 
IE 41184 6.0%
 
PL 26674 3.9%
 
ES 17325 2.5%
 
DE 11402 1.7%
 
PT 8112 1.2%
 
RO 8016 1.2%
 
LV 7865 1.1%
 
Other values (64) 77785 11.3%
 
(Missing) 49909 7.2%
 
Max length14
Mean length7.983416854
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsTrue

ROLLING_AVG
Numeric

Distinct count539512
Unique (%)78.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean5180059.39
Minimum0
Maximum2.716549277e+10
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1000
Q13091.45
Median5661.06
Q310313.355
95-th percentile44495.085
Maximum2.716549277e+10
Range2.716549277e+10
Interquartile range7221.905

Descriptive statistics

Standard deviation221151348.9
Coef of variation42.69282111
Kurtosis6617.474948
Mean5180059.39
MAD10129257.09
Skewness75.16437548
Sum3.567253079e+12
Variance4.890791912e+16
Memory size5.3 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000000e+00 1.65000000e-01 3.66500000e+00 4.50000000e+00 9.75000000e+00 ... 4.33386343e+09 4.57033444e+09 9.71912295e+09 1.54151738e+10 2.71654928e+10], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
126 4401 0.6%
 
111 3600 0.5%
 
693 1781 0.3%
 
611.5 1127 0.2%
 
25 620 0.1%
 
882 470 0.1%
 
1260 356 0.1%
 
504 352 0.1%
 
3214.5 307 < 0.1%
 
2837.5 274 < 0.1%
 
Other values (539502) 675363 98.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 169 < 0.1%
 
0.33 1 < 0.1%
 
0.5 1 < 0.1%
 
0.67 1 < 0.1%
 
1 8 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2.716549277e+10 1 < 0.1%
 
2.672733972e+10 1 < 0.1%
 
2.630309676e+10 1 < 0.1%
 
2.589211136e+10 1 < 0.1%
 
2.549377125e+10 1 < 0.1%
 

ROLLING_SUM
Numeric

Distinct count565098
Unique (%)82.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean848903689.5
Minimum0
Maximum1.657096214e+12
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile12518
Q1196310.5
Median662280
Q31840874
95-th percentile8690098
Maximum1.657096214e+12
Range1.657096214e+12
Interquartile range1644563.5

Descriptive statistics

Standard deviation2.566105873e+10
Coef of variation30.22846884
Kurtosis3026.587552
Mean848903689.5
MAD1654299448
Skewness51.60844599
Sum5.845983747e+14
Variance6.584899349e+20
Memory size5.3 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000000e+00 5.00000000e-01 3.00000000e+00 4.50000000e+00 9.50000000e+00 ... 1.65709521e+12 1.65709533e+12 1.65709589e+12 1.65709614e+12 1.65709621e+12], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
126 3302 0.5%
 
111 2430 0.4%
 
1386 1670 0.2%
 
1223 1051 0.2%
 
252 572 0.1%
 
222 524 0.1%
 
25 483 0.1%
 
2646 461 0.1%
 
1512 356 0.1%
 
1260 316 < 0.1%
 
Other values (565088) 677486 98.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 169 < 0.1%
 
1 9 < 0.1%
 
2 4 < 0.1%
 
4 39 < 0.1%
 
5 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.657096214e+12 1 < 0.1%
 
1.657096211e+12 1 < 0.1%
 
1.657096206e+12 1 < 0.1%
 
1.657096205e+12 1 < 0.1%
 
1.657096205e+12 1 < 0.1%
 

SOURCE
Categorical

Distinct count11
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
GAIA
483831
HERA
116081
INTERNAL
 
56407
Other values (8)
 
32332
ValueCountFrequency (%) 
GAIA 483831 70.3%
 
HERA 116081 16.9%
 
INTERNAL 56407 8.2%
 
MINOS 11056 1.6%
 
LETO 6935 1.0%
 
CRONUS 6139 0.9%
 
NYX 5178 0.8%
 
OPHION 1278 0.2%
 
LIMOS 961 0.1%
 
APOLLO 784 0.1%
 
Max length8
Mean length4.361387699
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

TERMS_VERSION
Categorical

Distinct count8
Unique (%)< 0.1%
Missing (%)11.0%
Missing (n)75567
2018-09-20
298644
2018-05-25
213103
2018-03-20
78458
Other values (4)
 
22879
(Missing)
75567
ValueCountFrequency (%) 
2018-09-20 298644 43.4%
 
2018-05-25 213103 30.9%
 
2018-03-20 78458 11.4%
 
2018-01-01 7345 1.1%
 
2017-01-16 6844 1.0%
 
2018-01-13 5585 0.8%
 
2017-02-02 3105 0.5%
 
(Missing) 75567 11.0%
 
Max length10
Mean length9.341608449
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

TIME_SINCE_LAST_TRANSACTION
Numeric

Distinct count34188
Unique (%)5.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3202.712086
Minimum0
Maximum1514745
Zeros (%)14.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q110
Median199
Q31272
95-th percentile10377
Maximum1514745
Range1514745
Interquartile range1262

Descriptive statistics

Standard deviation19712.5374
Coef of variation6.15495145
Kurtosis690.4626931
Mean3202.712086
MAD4763.704205
Skewness21.23906615
Sum2205550881
Variance388584130.8
Memory size5.3 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000000e+00 5.000000e-01 1.500000e+00 2.500000e+00 3.500000e+00 ... 4.911015e+05 5.938740e+05 8.208985e+05 1.056699e+06 1.514745e+06], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 96868 14.1%
 
1 21593 3.1%
 
2 12015 1.7%
 
3 8475 1.2%
 
4 6797 1.0%
 
5 5660 0.8%
 
6 4855 0.7%
 
7 4414 0.6%
 
8 4020 0.6%
 
9 3932 0.6%
 
Other values (34178) 520022 75.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 96868 14.1%
 
1 21593 3.1%
 
2 12015 1.7%
 
3 8475 1.2%
 
4 6797 1.0%
 

Maximum 5 values

ValueCountFrequency (%) 
1514745 1 < 0.1%
 
1283293 1 < 0.1%
 
1151261 1 < 0.1%
 
1139724 1 < 0.1%
 
1061079 1 < 0.1%
 

TRANSACTION_DATE
Numeric

Distinct count688640
Unique (%)> 99.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1016.787528
Minimum0
Maximum1246.064319
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile536.7981409
Q1908.4072873
Median1095.676915
Q31186.924301
95-th percentile1235.155439
Maximum1246.064319
Range1246.064319
Interquartile range278.5170136

Descriptive statistics

Standard deviation221.8661987
Coef of variation0.2182031079
Kurtosis1.150564108
Mean1016.787528
MAD175.7797174
Skewness-1.306616991
Sum700211747.9
Variance49224.61012
Memory size5.3 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 127.56242037 142.79027532 149.95207432 159.89678037 ... 1245.59855462 1245.70085707 1245.75656036 1245.88612014 1246.06431891], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1179.053614 2 < 0.1%
 
1227.960335 2 < 0.1%
 
1187.160424 2 < 0.1%
 
1222.209915 2 < 0.1%
 
1146.055195 2 < 0.1%
 
1158.768694 2 < 0.1%
 
1168.202019 2 < 0.1%
 
1172.837944 2 < 0.1%
 
1222.910702 2 < 0.1%
 
406.8574973 2 < 0.1%
 
Other values (688630) 688631 > 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 < 0.1%
 
1.984719109 1 < 0.1%
 
56.34827697 1 < 0.1%
 
56.35596095 1 < 0.1%
 
56.37551001 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1246.064319 1 < 0.1%
 
1246.064063 1 < 0.1%
 
1246.06386 1 < 0.1%
 
1246.063738 1 < 0.1%
 
1246.063441 1 < 0.1%
 

TRANSACTION_STATE
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
COMPLETED
584507
DECLINED
 
45635
REVERTED
 
38663
Other values (4)
 
19846
ValueCountFrequency (%) 
COMPLETED 584507 84.9%
 
DECLINED 45635 6.6%
 
REVERTED 38663 5.6%
 
FAILED 16763 2.4%
 
PENDING 2477 0.4%
 
CANCELLED 515 0.1%
 
RECORDED 91 < 0.1%
 
Max length9
Mean length8.797238369
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

TYPE
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
CARD_PAYMENT
436570
TOPUP
132561
P2P
 
56338
Other values (2)
 
63182
ValueCountFrequency (%) 
CARD_PAYMENT 436570 63.4%
 
TOPUP 132561 19.2%
 
P2P 56338 8.2%
 
ATM 47324 6.9%
 
BANK_TRANSFER 15858 2.3%
 
Max length13
Mean length9.320809815
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

USER_ID
Categorical

Distinct count8021
Unique (%)1.2%
Missing (%)0.0%
Missing (n)0
84e22e7f-f2ab-413c-969a-667c78d8885c
 
2725
26e8432c-5fdb-4b67-82e6-18f341d511a1
 
2571
f54baeeb-7282-4d23-9bb7-e8396ce1b159
 
2293
Other values (8018)
681062
ValueCountFrequency (%) 
84e22e7f-f2ab-413c-969a-667c78d8885c 2725 0.4%
 
26e8432c-5fdb-4b67-82e6-18f341d511a1 2571 0.4%
 
f54baeeb-7282-4d23-9bb7-e8396ce1b159 2293 0.3%
 
8dd8b009-bcc7-4b14-a26f-c87c232383f4 1888 0.3%
 
4366241f-0cac-4978-a4a3-27f38abc174a 1856 0.3%
 
d1bc3cd6-154e-479f-8957-a69cdf414462 1844 0.3%
 
0314aa87-cf7e-43f2-86c6-ae36dfa4d9b0 1802 0.3%
 
dc78fbc4-c936-45d3-a813-e2477ac6d74b 1725 0.3%
 
0fe472c9-cf3e-4e43-90f3-a0cfb6a4f1f0 1686 0.2%
 
6cae3eb6-515c-4811-8b51-32fb2e95da28 1559 0.2%
 
Other values (8011) 668702 97.1%
 
Max length36
Mean length36
Min length36
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Correlations

Missing values

Sample

First rows

ACCOUNT_CREATED_DATEAMOUNT_USDBIRTH_YEARCOUNTCOUNTRYCURRENCIES_USEDCURRENCYENTRY_METHODFAILED_SIGN_IN_ATTEMPTSHAS_EMAILIS_FRAUDSTERKYCMERCH_COUNTRIES_USEDMERCHANT_COUNTRYPHONE_COUNTRYROLLING_AVGROLLING_SUMSOURCETERMS_VERSIONTIME_SINCE_LAST_TRANSACTIONTRANSACTION_DATETRANSACTION_STATETYPEUSER_ID
0789.008585141989.01DK1DKKmisc0.01.0FalsePASSEDNaN0DK14.0014.0HERA2018-03-200.01100.318753REVERTEDTOPUP000e88bb-d302-4fdc-b757-2b1a2c33e7d6
1789.00858514901989.02DK1DKKmisc0.01.0FalsePASSEDNaN0DK752.001504.0HERA2018-03-200.01100.318955COMPLETEDTOPUP000e88bb-d302-4fdc-b757-2b1a2c33e7d6
2789.00858574511989.03DK1DKKmisc0.01.0FalsePASSEDNaN0DK2985.008955.0HERA2018-03-2062886.01143.990318COMPLETEDTOPUP000e88bb-d302-4fdc-b757-2b1a2c33e7d6
3789.00858588801989.04DK1DKKmisc0.01.0FalsePASSEDNaN0DK4458.7517835.0CRONUS2018-03-205.01143.994202COMPLETEDBANK_TRANSFER000e88bb-d302-4fdc-b757-2b1a2c33e7d6
4789.00858574511989.05DK1DKKmisc0.01.0FalsePASSEDNaN0DK5057.2025286.0HERA2018-03-2017633.01156.239779COMPLETEDTOPUP000e88bb-d302-4fdc-b757-2b1a2c33e7d6
5789.00858552161989.06DK1DKKmisc0.01.0FalsePASSEDNaN0DK5083.6730502.0INTERNAL2018-03-201.01156.240639COMPLETEDP2P000e88bb-d302-4fdc-b757-2b1a2c33e7d6
6789.0085855591989.07DK1DKKcont0.01.0FalsePASSED1.0FRADK4437.2931061.0GAIA2018-03-2055777.01194.975126REVERTEDCARD_PAYMENT000e88bb-d302-4fdc-b757-2b1a2c33e7d6
7789.0085855591989.08DK1DKKcont0.01.0FalsePASSED1.0FRADK3952.5031620.0GAIA2018-03-202.01194.977094REVERTEDCARD_PAYMENT000e88bb-d302-4fdc-b757-2b1a2c33e7d6
8789.008585891989.09DK1DKKcont0.01.0FalsePASSED1.0FRADK3523.2231709.0GAIA2018-03-20247.01195.148885COMPLETEDCARD_PAYMENT000e88bb-d302-4fdc-b757-2b1a2c33e7d6
9789.008585671989.010DK1DKKcont0.01.0FalsePASSED1.0FRADK3177.6031776.0GAIA2018-03-204.01195.151880COMPLETEDCARD_PAYMENT000e88bb-d302-4fdc-b757-2b1a2c33e7d6

Last rows

ACCOUNT_CREATED_DATEAMOUNT_USDBIRTH_YEARCOUNTCOUNTRYCURRENCIES_USEDCURRENCYENTRY_METHODFAILED_SIGN_IN_ATTEMPTSHAS_EMAILIS_FRAUDSTERKYCMERCH_COUNTRIES_USEDMERCHANT_COUNTRYPHONE_COUNTRYROLLING_AVGROLLING_SUMSOURCETERMS_VERSIONTIME_SINCE_LAST_TRANSACTIONTRANSACTION_DATETRANSACTION_STATETYPEUSER_ID
688641439.02643561986.050FR1EURmisc0.01.0FalsePASSEDNaN0FR3182.76159138.0LETO2018-09-200.01162.760362COMPLETEDTOPUPffd5d3f9-2f87-4f38-8e6d-f008ac79bb33
688642439.026435446131986.051FR1EURmisc0.01.0FalsePASSEDNaN0FR3995.12203751.0LETO2018-09-2022111.01178.115361COMPLETEDTOPUPffd5d3f9-2f87-4f38-8e6d-f008ac79bb33
688643439.02643542561986.052FR1EURchip0.01.0FalsePASSED1.0FRAFR4000.13208007.0GAIA2018-09-203259.01180.378689COMPLETEDCARD_PAYMENTffd5d3f9-2f87-4f38-8e6d-f008ac79bb33
688644439.02643533051986.053FR1EURchip0.01.0FalsePASSED1.0FRAFR3987.02211312.0GAIA2018-09-203492.01182.803769COMPLETEDCARD_PAYMENTffd5d3f9-2f87-4f38-8e6d-f008ac79bb33
688645439.02643511121986.054FR1EURmanu0.01.0FalsePASSED1.0FRAFR3933.78212424.0GAIA2018-09-208833.01188.937927COMPLETEDCARD_PAYMENTffd5d3f9-2f87-4f38-8e6d-f008ac79bb33
688646439.02643586651986.055FR1EURmanu0.01.0FalsePASSED4.0GBRFR4019.80221089.0GAIA2018-09-2048856.01222.865922COMPLETEDCARD_PAYMENTffd5d3f9-2f87-4f38-8e6d-f008ac79bb33
688647439.02643586651986.056FR1EURmanu0.01.0FalsePASSED4.0GBRFR4102.75229754.0GAIA2018-09-200.01222.866171DECLINEDCARD_PAYMENTffd5d3f9-2f87-4f38-8e6d-f008ac79bb33
688648439.02643520031986.057FR1EURmanu0.01.0FalsePASSED1.0FRAFR4065.91231757.0GAIA2018-09-2025834.01240.807053COMPLETEDCARD_PAYMENTffd5d3f9-2f87-4f38-8e6d-f008ac79bb33
688649929.089708231963.01RO1RONmisc0.01.0FalsePASSEDNaN0RO23.0023.0HERA2018-05-250.01236.891665REVERTEDTOPUPfff200b0-5204-4f7d-86eb-3bb5654b4636
688650929.08970823411963.02RO1RONmisc0.01.0FalsePASSEDNaN0RO1182.002364.0HERA2018-05-250.01236.891972COMPLETEDTOPUPfff200b0-5204-4f7d-86eb-3bb5654b4636